Converts a number entered as a text string to its corresponding numeric value.

Converts all the letters in a text string to uppercase.

Removes leading, trailing, and consecutive space characters from a text string.

Converts the value x to a text string with n decimal places.

Returns the entry in the first cell of a range as a text string; or an empty text string if the cell contains a value.

Returns the last n characters in a text string.

Replaces characters in a text string with characters from another text string.

Duplicates a text string n times.

Capitalizes the first letter of each word in a text string and converts the remaining letters to lowercase.

Returns the entry in the first cell of a range as a value. If the cell contains text, returns the value 0.

Returns n characters in a text string, beginning with a specified character.

Converts all the letters in a text string to lowercase.

Counts the number of characters in a text string.

Returns the first n characters in a text string.

Calculates the position of the first character of a text string within another text string.

Returns 1 (true) if two text strings match exactly; returns 0 (false) if they are not the same.

Returns the Lotus Multibyte Character set (LMBCS) code that corresponds to the first character in a text string.

Strips non-printable characters from a text string.

Returns the Lotus Multibyte Character Set (LMBCS) character that corresponds to the number x.